██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀                                     
    

Sets - Execution started 26/01/2023 19:11 UTC
By Guilherme Ruiz

---

Table of Contents

• 1  Data aquisition
  • 1.1  Fetch set lists
  • 1.2  Fetch set properties
  • 1.3  Merge data
  • 1.4  Save data
• 3  Check changes
  • 3.1  Load previous data
  • 3.2  Generate changelog
• 4  Data visualization
  • 4.1  Full data
  • 4.2  Set
  • 4.3  Card number
  • 4.4  Name
  • 4.5  Rarity
    • 4.5.1  By unique
    • 4.5.2  By combination
  • 4.6  Print
  • 4.7  Quantity
  • 4.8  Region
  • 4.9  Cover card
  • 4.10  Series
  • 4.11  Set type
  • 4.12  Release
    • 4.12.1  By year
    • 4.12.2  By month
    • 4.12.3  By day
    • 4.12.4  By region
    • 4.12.5  By series
    • 4.12.6  By set type
• 5  Debug
  • 5.1  Has nan name/number
  • 5.2  Has nan rarity
  • 5.3  Has quantity as print
  • 5.4  Has nan release
  • 5.5  Has print as rarity
  • 5.6  Merge failed
• 6  Epilogue
  • 6.1  HTML export

Data aquisition

Fetch set lists

  0%|          | 0/80 [00:00<?, ?it/s]

4120 set lists received - 76 errors

Fetch set properties

  0%|          | 0/96 [00:00<?, ?it/s]

1430 set properties received - 3 errors

Merge data

Set properties merged

Save data

Data saved

Check changes

Load previous data

File loaded

Generate changelog

	Print	Release	Modification date	Version
Card number
ADC1-EN001	Dark Magician	(Secret Rare,)	<NA>	2023-01-26	2023-01-26 09:17:24	New
BPT-J02	Chaos Emperor Dragon - Envoy of the End	(Ultimate Rare,)	<NA>	2004-01-21	2022-06-18 10:50:28	Old
BPT-J02	Chaos Emperor Dragon - Envoy of the End	(Ultimate Rare,)	<NA>	2004-01-22	2023-01-26 12:42:21	New
CL03-SC075	<NA>	NaN	<NA>	2023-02-25	2022-11-07 13:43:33	Old
CL03-SC075	Galaxy-Eyes Full Armor Photon Dragon	(Secret Rare,)	New	2023-02-25	2022-11-07 13:43:33	New
JF07-JP001	Voltic Kong	(Common, Normal Parallel Rare)	<NA>	2006-12-16	2019-03-13 23:29:15	Old
JF07-JP002	Botanical Lion	(Common, Normal Parallel Rare)	<NA>	2006-12-16	2019-03-13 23:29:15	Old
JF07-JP003	Gravity Behemoth	(Common, Normal Parallel Rare)	<NA>	2006-12-16	2019-03-13 23:29:15	Old
P4-01	Dark Magician Girl	(Ultra Rare,)	Reprint	2001-01-18	2022-07-26 20:40:41	Old
P4-01	Dark Magician Girl	(Ultra Rare,)	Reprint	2000-12-23	2023-01-26 11:26:47	New
P4-02	Dark Magician	(Ultra Rare,)	New artwork	2001-01-18	2022-07-26 20:40:41	Old
P4-02	Dark Magician	(Ultra Rare,)	New artwork	2000-12-23	2023-01-26 11:26:47	New
P4-03	Thousand Knives	(Ultra Rare,)	New	2001-01-18	2022-07-26 20:40:41	Old
P4-03	Thousand Knives	(Ultra Rare,)	New	2000-12-23	2023-01-26 11:26:47	New
P4-04	Dark Magic Curtain	(Ultra Rare,)	New	2001-01-18	2022-07-26 20:40:41	Old
P4-04	Dark Magic Curtain	(Ultra Rare,)	New	2000-12-23	2023-01-26 11:26:47	New
P4-05	Mystic Box	(Ultra Rare,)	New	2001-01-18	2022-07-26 20:40:41	Old
P4-05	Mystic Box	(Ultra Rare,)	New	2000-12-23	2023-01-26 11:26:47	New
P4-06	Magic Cylinder	(Ultra Rare,)	New	2001-01-18	2022-07-26 20:40:41	Old
P4-06	Magic Cylinder	(Ultra Rare,)	New	2000-12-23	2023-01-26 11:26:47	New

Changelog saved

Data visualization

Full data

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
0	Advanced Tournament Pack 2014 Vol.2	AT06-JP001	Cyber-Stein	(Normal Parallel Rare,)	<NA>	<NA>	JP	2014-04-19	<NA>	Booster pack	NaN	https://yugipedia.com/wiki/Advanced_Tournament...	2022-07-23 20:08:04	both
1	Advanced Tournament Pack 2014 Vol.2	AT06-JP002	Raiza the Storm Monarch	(Normal Parallel Rare,)	<NA>	<NA>	JP	2014-04-19	<NA>	Booster pack	NaN	https://yugipedia.com/wiki/Advanced_Tournament...	2022-07-23 20:08:04	both
2	Advanced Tournament Pack 2014 Vol.2	AT06-JP003	Djinn Releaser of Rituals	(Normal Parallel Rare,)	<NA>	<NA>	JP	2014-04-19	<NA>	Booster pack	NaN	https://yugipedia.com/wiki/Advanced_Tournament...	2022-07-23 20:08:04	both
3	Advanced Tournament Pack 2014 Vol.2	AT06-JP004	Lava Battleguard	(Common,)	<NA>	<NA>	JP	2014-04-19	<NA>	Booster pack	NaN	https://yugipedia.com/wiki/Advanced_Tournament...	2022-07-23 20:08:04	both
4	Advanced Tournament Pack 2014 Vol.2	AT06-JP005	Swamp Battleguard	(Common,)	<NA>	<NA>	JP	2014-04-19	<NA>	Booster pack	NaN	https://yugipedia.com/wiki/Advanced_Tournament...	2022-07-23 20:08:04	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
156159	Jump Festa 2004 promotional cards	PC3-007	Bazoo the Soul-Eater	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2003-12-20	<NA>	Tournament prize card	NaN	https://yugipedia.com/wiki/Jump_Festa_2004_pro...	2022-11-06 04:44:51	both
156160	Jump Festa 2005 promotional cards	PC5-JP007	Dark Balter the Terrible	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2004-12-18	<NA>	Promotional card	NaN	https://yugipedia.com/wiki/Jump_Festa_2005_pro...	2022-11-06 05:15:26	both
156161	Jump Festa 2005 promotional cards	PC5-JP008	Ryu Senshi	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2004-12-18	<NA>	Promotional card	NaN	https://yugipedia.com/wiki/Jump_Festa_2005_pro...	2022-11-06 05:15:26	both
156162	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156163	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

156164 rows × 14 columns

Full data available here

Set

Total number of sets: 1435

	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Set
"Amabie-San" Present Campaign	2	1	1	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign	2	1	1	0	0	2	2	0	1	0	1	1	1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign	1	1	1	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition	0	1	0	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition	0	1	0	0	0	1	1	0	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card	1	1	1	0	0	1	1	0	1	0	1	1	1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards	18	3	1	0	0	6	2	0	1	0	1	1	1
Yugi's Legendary Decks	650	112	3	0	0	5	2	0	1	0	1	1	1
Zexal Collection Tin	120	24	3	0	0	5	1	0	1	1	1	1	1
Zombie World Structure Deck	185	37	2	0	2	5	1	0	1	1	1	1	1

1435 rows × 13 columns

	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.0
mean	107.213240	27.545645	2.429965	0.349129	0.095470	2.696864	1.455052	0.390941	0.953310	0.310801	0.994425	0.994425	1.0
std	236.084401	45.356359	2.329801	0.812252	0.443393	2.298980	0.997155	0.488131	0.211047	0.462983	0.074483	0.074483	0.0
min	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.0
25%	1.000000	1.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	1.000000	0.000000	1.000000	1.000000	1.0
50%	10.000000	5.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	1.000000	0.000000	1.000000	1.000000	1.0
75%	86.000000	40.500000	3.000000	0.000000	0.000000	5.000000	2.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.0
max	1652.000000	307.000000	17.000000	6.000000	3.000000	10.000000	9.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.0

Card number

Total number of card numbers: 151985

	Set	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Card number
15AX-JP000	2	1	1	1	0	1	1	0	1	0	2	2	1
15AX-JPM01	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM02	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM03	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM04	1	1	1	1	0	1	1	0	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
ZTIN-SP021	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV01	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV02	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV03	1	1	1	0	0	1	1	0	1	1	1	1	1
<NA>	44	406	6	2	0	10	40	6	11	6	43	43	3

151986 rows × 13 columns

Name

Total number of card names: 12579

	Set	Card number	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Name
"A Legendary Ocean"	1	1	0	0	0	1	1	0	1	1	1	1	1
"A" Cell Breeding Device	4	9	1	1	0	7	6	1	2	3	4	4	1
"A" Cell Incubator	2	8	1	2	0	7	6	1	1	2	2	2	1
"A" Cell Recombination Device	1	8	1	0	0	8	4	1	1	1	1	1	1
"A" Cell Scatter Burst	3	9	1	1	0	7	6	1	1	3	3	3	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Zubaba Knight	12	50	5	1	1	8	23	2	2	7	12	12	1
Zubababancho Gagagacoat	1	2	1	1	0	2	2	1	1	1	1	1	1
Zure, Knight of Dark World	8	24	1	1	1	10	14	1	4	4	8	8	1
Zushin the Sleeping Giant	3	14	3	1	0	8	4	1	2	3	3	3	1
<NA>	9	178	3	0	0	9	12	4	4	4	9	9	2

12580 rows × 13 columns

	Set	Card number	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	12579.000000	12579.00000	12579.000000	12579.00000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000
mean	3.142380	12.06956	2.071786	0.67096	0.107481	6.894189	5.982988	1.090230	1.473329	1.843469	3.131092	3.131092	1.010812
std	3.515904	11.60573	1.493724	0.67360	0.336553	2.561692	5.904608	0.788018	0.936945	1.841657	3.495276	3.495276	0.103420
min	1.000000	0.00000	0.000000	0.00000	0.000000	1.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.000000
25%	1.000000	7.00000	1.000000	0.00000	0.000000	6.000000	3.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.000000
50%	2.000000	9.00000	2.000000	1.00000	0.000000	8.000000	4.000000	1.000000	1.000000	1.000000	2.000000	2.000000	1.000000
75%	4.000000	14.00000	3.000000	1.00000	0.000000	8.000000	7.000000	1.000000	2.000000	2.000000	4.000000	4.000000	1.000000
max	80.000000	275.00000	28.000000	4.00000	3.000000	15.000000	122.000000	12.000000	16.000000	41.000000	80.000000	80.000000	2.000000

Rarity

Total number of rarities: 55

By unique

	Set	Card number	Name	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Rarity
10000 Secret Rare	2	7	1	1	0	7	2	1	1	2	2	2	1
20th Secret Rare	16	135	134	3	0	1	13	3	3	6	16	16	1
@released::(from July 17)	1	1	1	0	0	1	0	0	0	0	1	1	1
@released::(from July 31)	1	1	1	0	0	1	0	0	0	0	1	1	1
@released::(from September 18)	1	2	1	0	0	1	0	0	0	0	1	1	1
Collector's Rare	6	301	76	2	0	7	6	2	1	6	6	6	1
Collectors Rare	8	112	112	2	0	1	8	1	1	7	8	8	1
Common	555	76872	8561	6	3	17	920	25	23	268	553	553	2
Duel Terminal Normal Parallel Rare	38	1906	511	2	0	7	34	1	3	11	38	38	1
Duel Terminal Normal Rare Parallel Rare	5	15	15	0	0	1	5	0	1	4	5	5	1
Duel Terminal Rare Parallel Rare	34	368	141	2	0	2	31	0	1	10	34	34	1
Duel Terminal Secret Parallel Rare	16	103	55	1	0	1	16	0	1	10	16	16	1
Duel Terminal Super Parallel Rare	34	240	85	2	0	2	31	0	1	10	34	34	1
Duel Terminal Ultra Parallel Rare	42	371	87	2	0	7	33	1	5	18	42	42	1
Extra Secret Parallel Rare	3	10	6	0	0	2	4	0	2	1	3	3	1
Extra Secret Rare	24	77	50	1	1	3	31	3	5	17	24	24	1
Ghost Rare	35	255	47	3	0	7	63	1	2	34	35	35	1
Ghost/Gold Rare	1	30	6	0	0	5	2	1	1	0	1	1	1
Gold Rare	23	2057	363	2	0	9	39	3	5	0	23	23	1
Gold Rush Rare	2	16	16	2	0	1	2	0	1	1	2	2	1
Gold Secret Rare	8	644	154	2	0	9	17	1	3	0	8	8	1
Holographic Parallel Rare	2	2	2	1	0	1	2	0	1	0	2	2	1
Holographic Rare	68	123	65	2	0	6	121	3	2	65	68	68	1
Kaiba Corporation Common	10	10	10	0	0	1	8	0	1	0	10	10	1
Kaiba Corporation Rare	5	5	5	0	0	1	5	1	2	0	5	5	1
Kaiba Corporation Ultra Rare	3	3	3	0	0	1	3	0	2	0	3	3	1
Millennium Gold Rare	2	9	6	2	0	2	2	0	1	2	2	2	1
Millennium Rare	8	316	152	3	0	3	9	2	6	2	8	8	1
Millennium Secret Rare	1	4	2	1	0	2	0	0	1	1	1	1	1
Millennium Super Rare	1	40	20	1	0	2	0	0	1	1	1	1	1
Millennium Ultra Rare	1	16	8	1	0	2	0	0	1	1	1	1	1
Mosaic Rare	1	1290	215	0	0	6	2	0	1	1	1	1	1
New	2	1	18	1	1	1	2	1	2	2	2	2	1
Normal Parallel Rare	130	2068	994	4	1	4	162	7	10	61	130	130	1
Normal Rare	81	575	299	2	0	7	151	3	2	72	81	81	1
Orr	1	1	1	0	0	1	1	1	1	1	1	1	1
Platinum Secret Rare	2	24	4	0	0	6	4	0	1	2	2	2	1
Prismatic Secret Rare	40	1391	367	3	0	11	48	6	4	15	40	40	1
Rare	249	18684	3501	7	2	15	545	13	8	177	248	248	2
Reprint	6	0	35	0	0	1	6	3	1	1	6	6	1
Rr	1	4	4	0	0	1	1	1	1	1	1	1	1
Rush Rare	15	102	47	0	0	2	27	1	2	12	15	15	1
Secret Parallel Rare	2	12	6	1	0	2	4	0	1	0	2	2	1
Secret Rare	374	10360	2294	11	1	15	533	20	20	200	369	369	2
Shatterfoil Rare	4	1482	292	0	1	7	5	1	2	4	4	4	1
Short Print	56	1316	234	3	0	10	110	3	1	46	56	56	1
Starfoil Rare	6	2019	380	0	0	6	9	1	3	4	6	6	1
Starlight Rare	12	316	56	2	0	6	13	1	1	12	12	12	1
Super Parallel Rare	6	154	82	3	1	3	10	1	3	2	6	6	1
Super Rare	585	20266	3888	9	1	17	953	26	20	276	581	581	2
Super Short Print	1	35	5	1	0	7	0	1	1	1	1	1	1
Ultimate Rare	115	4315	847	2	1	11	278	5	6	85	114	114	2
Ultra Parallel Rare	67	279	170	3	1	7	63	4	7	20	66	66	2
Ultra Rare	784	17963	3172	7	2	17	1069	33	26	278	782	782	2
Ultra Secret Rare	1	0	6	0	0	1	1	1	1	0	1	1	1
NaN	36	381	367	2	0	6	30	5	9	4	35	35	3

By combination

	Set	Card number	Name	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Rarity
(10000 Secret Rare,)	2	7	1	1	0	7	2	1	1	2	2	2	1
(20th Secret Rare,)	9	25	24	1	0	1	8	2	3	1	9	9	1
(@released::(from July 17),)	1	1	1	0	0	1	0	0	0	0	1	1	1
(@released::(from July 31),)	1	1	1	0	0	1	0	0	0	0	1	1	1
(@released::(from September 18),)	1	2	1	0	0	1	0	0	0	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
(Ultra Rare, Ultimate Rare, Ultra Parallel Rare)	1	1	1	0	0	1	1	1	1	1	1	1	1
(Ultra Rare, Ultra Parallel Rare)	22	71	67	0	0	1	16	3	2	16	21	21	2
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare)	5	5	5	0	0	1	3	2	1	3	5	5	1
(Ultra Secret Rare,)	1	0	6	0	0	1	1	1	1	0	1	1	1
NaN	36	381	367	2	0	6	30	5	9	4	35	35	3

127 rows × 13 columns

Print

Total number of prints: 17

	Set	Card number	Name	Rarity	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Print
2	1	0	1	0	0	1	1	0	1	1	1	1	1
American debut	1	3	3	1	0	1	1	0	1	1	1	1	1
European & Oceanian debut	1	6	6	1	0	1	1	0	1	0	1	1	1
European debut	12	146	146	5	0	2	10	0	2	1	12	12	1
Functional errata	1	2	2	1	0	1	1	0	1	1	1	1	1
New	226	11754	3870	50	3	11	243	18	13	129	224	224	2
New art	1	4	2	1	0	2	2	0	1	1	1	1	1
New artwork	10	74	15	5	0	7	12	3	4	4	10	10	1
New artwork (renamed)	1	3	3	1	0	1	1	0	1	0	1	1	1
North American debut	2	4	4	2	0	2	2	0	2	0	2	2	1
Oceanian debut	1	1	1	1	0	1	1	0	1	0	1	1	1
Reprint	223	14034	4287	49	3	11	240	17	12	127	221	221	2
Reprint (New Art)	2	2	1	2	0	2	2	1	1	1	2	2	1
Reprint (functional errata)	15	33	21	10	0	8	14	3	3	5	15	15	1
Reprint (new artwork)	1	1	1	1	0	1	1	0	1	1	1	1	1
Reprint (renamed)	2	76	76	6	0	1	2	1	1	0	2	2	1
TCG legal debut	1	1	1	1	0	1	1	1	1	1	1	1	1
<NA>	1356	126018	11478	115	3	17	1453	42	37	315	1348	1348	3

Quantity

Total number of quantities: 3

	Set	Card number	Name	Rarity	Print	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Quantity
1	65	8760	1167	11	2	11	107	1	5	44	64	64	2
2	64	839	165	4	2	11	107	1	5	43	63	63	2
3	8	64	20	1	2	8	11	0	3	6	8	8	1
<NA>	1372	142334	12503	125	17	17	1502	45	36	316	1364	1364	3

Region

Total number of regions: 17

	Set	Card number	Name	Rarity	Print	Quantity	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Region
AE	34	1527	1493	12	0	2	31	2	7	19	34	34	1
AU	2	100	87	3	0	0	1	0	1	2	2	2	1
DE	455	20372	10393	45	4	3	381	12	18	219	454	454	2
EN	658	20184	10480	51	14	3	536	22	23	207	657	657	2
ES	1	100	100	7	0	0	1	1	1	1	1	1	1
EU	25	543	456	8	3	0	16	2	9	6	25	25	1
FC	3	102	87	3	0	0	1	0	2	2	3	3	1
FR	448	19776	10380	46	4	3	375	14	18	219	447	447	2
IT	447	20051	10388	46	4	3	378	12	18	218	446	446	2
JA	3	185	185	8	0	0	3	2	2	3	3	3	1
JP	714	19087	11213	94	7	3	530	28	28	247	709	709	2
KR	383	15937	10755	55	4	3	333	16	15	224	378	378	2
NA	47	1526	1333	10	4	2	39	5	11	12	47	47	1
PT	204	12461	7823	40	4	3	165	8	10	120	204	204	1
SC	23	1237	1042	12	2	0	23	5	1	12	23	23	1
SP	416	19111	10221	45	4	3	355	9	17	204	415	415	2
TC	7	300	286	12	0	2	5	2	2	3	7	7	1
<NA>	2	0	0	0	0	0	0	0	0	0	2	2	1

	Set	Card number	Name	Rarity	Print	Quantity	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000
mean	215.111111	8477.722222	4817.888889	27.611111	3.000000	1.666667	176.277778	7.777778	10.166667	95.444444	214.277778	214.277778	1.388889
std	252.440299	9290.417314	5018.748343	25.836907	3.497899	1.414214	203.640342	8.156957	8.759868	105.784032	251.351829	251.351829	0.501631
min	1.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.000000	1.000000	1.000000
25%	4.000000	213.750000	210.250000	8.000000	0.000000	0.000000	3.500000	2.000000	2.000000	3.000000	4.000000	4.000000	1.000000
50%	40.500000	1526.500000	1413.000000	12.000000	3.500000	2.000000	35.000000	5.000000	9.500000	15.500000	40.500000	40.500000	1.000000
75%	439.250000	19105.000000	10386.000000	45.750000	4.000000	3.000000	370.000000	12.000000	17.750000	215.250000	438.250000	438.250000	2.000000
max	714.000000	20372.000000	11213.000000	94.000000	14.000000	3.000000	536.000000	28.000000	28.000000	247.000000	709.000000	709.000000	2.000000

Cover card

Total number of cover cards: 671

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Page URL	Modification date	_merge
Cover card
A-to-Z-Dragon Buster Cannon	1	352	54	4	2	2	8	4	0	1	1	1	1
Accel Synchro Stardust Dragon	1	100	50	3	2	0	2	2	0	1	1	1	1
Accesscode Talker	1	766	101	16	2	0	8	3	1	1	1	1	1
Adamancipator Risen - Dragite	1	135	45	3	2	0	3	3	0	1	1	1	1
Adreus, Keeper of Armageddon	1	84	42	4	0	0	2	2	0	1	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yamiterasu the Divine Ruler	1	132	66	6	0	0	2	2	1	1	1	1	1
Yoko, the Graceful Mayakashi	2	450	60	4	2	0	8	3	0	1	2	2	1
Yubel - The Ultimate Nightmare	2	560	100	10	0	0	6	5	1	2	2	2	1
Z-Metal Tank	1	55	55	7	0	0	1	1	1	1	1	1	1
Zerrziel, Ruler of the Evil Eyed	1	90	45	3	2	0	2	2	0	1	1	1	1

671 rows × 13 columns

Series

Total number of series: 45

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Set type	Cover card	Page URL	Modification date	_merge
Series
+1 Bonus Pack	7	249	137	3	0	0	2	12	1	0	7	7	1
Animation Chronicle	2	200	100	7	2	0	2	4	1	2	2	2	1
Astral Pack	7	1110	184	4	4	0	6	16	1	0	7	7	1
Attribute Duelist Pack	4	429	199	6	3	0	3	9	1	4	4	4	1
Battle Pack (Rush Duel)	8	80	80	3	3	0	1	8	1	0	8	8	1
Booster (series)	4	181	176	8	0	0	1	4	1	2	4	4	1
Booster pack	1	50	50	3	0	0	1	1	1	0	1	1	1
Champion Pack	8	640	161	4	2	0	4	8	1	0	8	8	1
Classic Pack	3	570	419	9	2	0	1	3	1	2	3	3	1
Collectors Pack	8	794	374	12	3	0	3	16	1	8	8	8	1
Core Booster	88	49929	7471	39	2	0	14	296	1	80	88	88	1
Deck Build Pack	3	360	134	5	2	0	3	8	1	3	3	3	1
Deck Mod Pack	12	1447	756	10	0	0	2	23	1	12	12	12	1
Duelist Pack	21	3739	634	7	3	0	8	49	1	19	21	21	1
Entry Pack (series)	10	163	160	3	2	0	1	10	1	0	10	10	1
Expansion Pack	4	280	280	6	0	0	1	4	1	0	4	4	1
Gold Series (series)	8	2595	446	9	2	0	9	18	1	0	8	8	1
Hidden Arsenal (series)	7	2470	400	2	2	0	7	16	1	7	7	7	1
Hobby League	1	83	43	3	0	0	5	0	1	0	1	1	1
Jump Victory Carnival	1	1	1	1	0	0	1	1	1	0	1	1	1
Legend Duelist (series)	6	780	343	9	2	0	3	14	1	6	6	6	1
Legendary Collection (series)	2	57	19	1	2	0	3	4	1	0	2	2	1
Master Guide promotional cards (series)	4	8	8	1	0	0	1	4	1	0	4	4	1
Mattel Action Figure promotional cards	3	17	16	1	0	0	1	3	1	0	3	3	1
McDonald's Promotional Cards	2	35	35	4	3	0	2	2	1	0	2	2	1
Monster Figure Collection promotional cards	3	15	15	1	0	0	1	3	1	0	3	3	1
OTS Tournament Pack	2	324	54	4	0	0	6	3	1	0	2	2	1
Perfect Rulebook promotional cards	3	3	3	2	0	0	1	3	1	0	3	3	1
Pharaoh Tour promotional cards	3	20	5	2	0	0	4	3	1	0	3	3	1
Premium Pack	25	452	368	9	3	0	2	25	1	12	25	25	1
Shonen Jump promotional cards	78	85	81	2	0	0	2	44	1	0	78	78	1
Sneak Peek Participation Cards	57	302	61	2	0	0	8	69	1	0	57	57	1
Star Pack	3	900	149	4	0	0	6	6	1	3	3	3	1
Structure Deck R	3	248	122	5	2	2	2	6	1	3	3	3	1
The Valuable Book promotional cards	18	38	38	2	0	0	2	19	1	0	18	18	1
V Jump August 1999 Special Present	1	0	6	1	0	0	1	1	1	0	1	1	1
V Jump Edition (series)	4	16	16	3	0	0	1	4	1	0	4	4	1
V Jump promotional cards	78	94	98	5	0	0	1	74	1	0	78	78	1
Value Box	9	11	11	3	0	0	1	7	1	0	9	9	1
Yu-Gi-Oh! 5D's manga promotional cards	9	19	9	1	0	0	3	18	1	0	9	9	1
Yu-Gi-Oh! Day promotional cards	7	7	1	1	0	0	2	7	1	0	7	7	1
Yu-Gi-Oh! GX manga promotional cards	9	19	9	2	0	0	3	17	1	0	9	9	1
Yu-Gi-Oh! R promotional cards	4	8	4	2	0	0	2	8	1	0	4	4	1
Yu-Gi-Oh! World Championship prize cards	13	35	30	5	0	0	3	13	1	0	13	13	1
Yu-Gi-Oh! ZEXAL manga promotional cards	8	25	8	1	0	0	4	25	1	0	8	8	1

Set type

Total number of set types: 37

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Cover card	Page URL	Modification date	_merge
Set type
Beta set	1	535	106	1	0	2	5	1	0	0	1	1	1
Binder	2	6	6	2	2	0	1	2	0	0	2	2	1
Book promotional card	4	5	5	3	0	0	2	4	1	0	4	4	1
Book promotional cards	26	52	52	4	0	0	2	27	2	0	26	26	1
Booster pack	467	114012	11764	104	15	0	15	809	23	223	467	467	1
Boss Duel Deck	1	8	8	1	0	0	1	1	0	0	1	1	1
Bundle	9	11	11	3	0	0	1	7	1	0	9	9	1
Collectible tin	53	5901	1005	9	4	0	8	66	0	35	53	53	1
Collector's Set	11	6226	1102	7	2	3	7	14	0	6	11	11	1
Core Booster	1	160	80	6	0	0	2	2	0	1	1	1	1
Deluxe Edition	4	114	19	2	0	0	6	8	0	4	4	4	1
Demo Deck	4	380	64	1	0	0	7	8	0	1	4	4	1
Duel Disk	2	16	9	2	2	0	2	4	0	0	2	2	1
Duel Disk promotional cards	5	13	12	4	0	0	2	5	0	0	5	5	1
Duel Terminal	34	1847	706	6	2	0	2	31	0	10	34	34	1
Duelist League participation cards	10	60	16	3	0	0	9	9	0	0	10	10	1
Duelist Set	5	312	154	5	0	2	2	5	0	5	5	5	1
Enhancement Pack	2	20	20	1	0	0	1	1	0	0	2	2	1
Hobby League participation cards	40	83	43	3	0	0	5	38	0	0	40	40	1
Magazine promotional card	167	191	173	9	0	0	3	127	3	7	167	167	1
Magazine promotional cards	4	4	4	1	0	0	2	2	0	0	4	4	1
Main Deck	2	44	44	2	0	0	1	2	0	1	2	2	1
Manga promotional card	33	74	32	2	0	0	4	69	4	0	33	33	1
Participation card	60	485	119	5	0	0	9	71	2	0	60	60	1
Preconstructed Deck	6	401	223	10	3	0	2	8	0	4	6	6	1
Prize card	16	46	41	5	0	0	3	16	1	0	16	16	1
Prize cards	1	68	20	1	0	0	5	1	0	0	1	1	1
Promotional card	140	315	206	18	3	0	9	141	6	21	140	140	1
Promotional cards	25	200	62	7	2	0	10	34	1	1	25	25	1
Special Edition	90	1189	289	9	5	0	10	109	0	1	90	90	1
Starter Deck	38	6777	606	11	3	3	14	59	0	26	38	38	1
Structure Deck	64	9454	1206	9	2	3	10	117	1	45	64	64	1
Tournament prize card	1	2	2	1	0	0	1	1	0	0	1	1	1
Tournament promotional card	2	5	2	2	0	0	2	2	0	0	2	2	1
Vendor Edition	6	210	210	2	0	0	1	6	0	0	6	6	1
Video game promotional card	9	79	39	4	0	0	8	15	0	0	9	9	1
Video games promotional card	23	325	73	4	2	0	9	43	0	0	23	23	1

Release

Total number of release dates: 1573

	Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Set type	Cover card	Page URL	Modification date	_merge
Release
1999-03-01	1	0	40	1	0	0	1	1	1	0	1	1	1
1999-03-18	1	0	1	0	0	0	1	0	1	0	1	1	1
1999-04-29	1	0	1	0	0	0	1	0	1	0	1	1	1
1999-05-05	1	0	1	0	0	0	1	0	1	0	1	1	1
1999-05-25	1	0	40	1	0	0	1	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
2023-01-26	1	1	1	1	0	0	1	0	1	0	1	1	1
2023-02-25	1	190	39	5	2	0	1	1	1	0	1	1	1
2023-03-01	3	2	3	2	0	0	1	0	1	0	3	3	1
2023-05-01	3	3	3	1	0	0	1	0	1	0	3	3	1
NaT	119	3971	1085	26	4	2	13	9	13	14	111	111	3

1574 rows × 13 columns

By year

	Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Set type	Cover card	Page URL	_merge
Release
1999	18	0	353	10	2	0	15	8	15	1	18	15
2000	12	274	324	22	5	2	10	8	11	5	12	10
2001	12	305	307	29	4	4	12	4	11	6	12	12
2002	22	1369	1197	81	10	2	21	9	20	14	22	19
2003	51	2669	2263	123	12	0	52	12	41	29	51	38
2004	93	6502	4687	193	6	0	108	27	74	45	93	59
2005	75	7826	4043	160	27	18	127	28	64	37	75	49
2006	101	5241	3045	185	22	20	125	39	92	42	101	67
2007	126	5744	3344	272	16	18	192	53	115	54	126	94
2008	124	5979	3248	267	21	12	194	51	113	50	124	95
2009	117	5104	2973	278	6	14	172	40	111	54	117	93
2010	138	6093	3322	309	8	16	204	58	124	53	138	103
2011	144	6922	3952	318	16	18	214	55	133	53	144	105
2012	141	10271	5425	349	17	20	218	57	128	53	141	111
2013	146	8913	4469	340	18	24	222	68	129	69	146	108
2014	141	12625	5705	381	38	20	225	68	126	60	141	107
2015	136	10432	4828	353	33	12	221	69	125	57	136	103
2016	137	10356	4755	331	39	10	210	62	124	59	137	97
2017	67	8404	3324	198	27	6	140	29	64	35	67	54
2018	46	5413	2129	140	26	0	103	20	41	28	46	41
2019	50	6264	2670	160	29	0	101	17	45	25	50	43
2020	38	6435	2143	150	34	0	85	18	36	27	38	36
2021	65	6812	2733	241	46	6	91	38	53	36	65	49
2022	73	8953	3673	249	66	3	96	43	61	42	73	56
2023	15	798	348	41	7	0	15	7	9	4	15	9

By month

By day

By region

		Set	Card number	Name	Rarity	Print	Quantity	Series	Set type	Cover card	Page URL	Modification date	_merge
Region	Release
AE	2001-06-04	1	0	2	0	0	0	0	0	0	1	1	1
	2002-08-08	2	100	87	3	0	0	0	1	2	2	2	1
	2002-10-24	1	144	144	5	0	0	1	1	1	1	1	1
	2003-04-17	1	3	3	1	0	0	0	1	0	1	1	1
	2003-06-26	1	105	105	5	0	0	1	1	1	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
TC	2014-01-29	1	40	40	4	0	2	0	1	1	1	1	1
	2014-05-01	1	20	20	4	0	0	1	1	0	1	1	1
	2015-03-01	2	40	26	1	0	0	0	0	0	2	2	1
	2015-08-29	1	100	100	6	0	0	1	1	1	1	1	1
	2015-12-05	1	100	100	6	0	0	1	1	1	1	1	1

3173 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Region
AE	0	0	1	3	4	3	3	5	2	1	4	1	1	1	1	1	1	0	0	0	0	0	0	0	0
AU	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
DE	0	0	0	0	8	21	22	17	31	27	23	28	31	30	28	30	27	28	20	15	13	10	8	7	1
EN	0	0	2	2	3	16	29	48	50	45	33	45	47	49	42	43	34	35	20	15	13	10	12	11	2
ES	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0
EU	0	0	0	2	2	4	0	0	0	2	0	2	0	0	0	2	2	1	0	0	0	0	0	0	0
FC	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
FR	0	0	0	0	5	20	22	17	31	27	23	27	28	30	29	28	27	28	19	15	13	10	8	7	1
IT	0	0	0	0	5	20	21	17	31	27	23	27	29	30	28	28	27	28	20	15	13	10	8	7	1
JA	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0
JP	18	12	9	11	11	20	24	26	32	40	40	49	46	44	49	43	43	52	14	16	20	14	25	26	10
KR	0	0	0	0	2	8	7	13	20	24	21	21	30	29	29	23	22	21	17	10	12	10	23	26	1
NA	0	0	0	5	16	6	0	2	2	1	2	1	1	0	0	2	3	0	2	0	0	0	0	0	0
PT	0	0	0	0	0	10	6	0	0	0	0	0	0	1	24	24	25	26	18	14	13	9	8	7	1
SC	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4	7	10	2
SP	0	0	0	0	4	20	20	10	24	22	21	27	27	30	27	28	27	28	19	14	13	10	9	7	1
TC	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	4	0	0	0	0	0	0	0	0

By series

		Set	Card number	Name	Rarity	Print	Quantity	Region	Set type	Cover card	Page URL	Modification date	_merge
Series	Release
+1 Bonus Pack	2020-10-31	1	19	19	3	0	0	1	1	0	1	1	1
	2021-02-04	1	20	20	3	0	0	1	1	0	1	1	1
	2021-04-17	1	19	19	3	0	0	1	1	0	1	1	1
	2021-07-17	1	19	19	3	0	0	1	1	0	1	1	1
	2021-07-21	1	19	19	3	0	0	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yu-Gi-Oh! ZEXAL manga promotional cards	2015-09-01	1	1	1	1	0	0	1	1	0	1	1	1
	2015-10-03	1	1	1	1	0	0	1	1	0	1	1	1
	2015-12-18	1	1	1	1	0	0	1	1	0	1	1	1
	2016-03-01	1	1	1	1	0	0	1	1	0	1	1	1
	2016-09-06	1	1	1	1	0	0	1	1	0	1	1	1

888 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Series
+1 Bonus Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	6	4	1
Animation Chronicle	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	0
Astral Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5	8	3	0	0	0	0	0	0	0	0
Attribute Duelist Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	3	4	0
Battle Pack (Rush Duel)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	4	1
Booster (series)	0	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Booster pack	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Champion Pack	0	0	0	0	0	0	0	1	3	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Classic Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1
Collectors Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	2	2	2	2	2	2	0	0	0
Core Booster	6	0	2	6	11	22	17	17	25	13	14	15	14	16	18	16	17	16	12	10	8	6	8	8	1
Deck Build Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	6	0
Deck Mod Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4	9	8	2
Duelist Pack	0	0	0	0	0	0	2	9	9	10	4	6	7	3	3	1	3	5	1	0	0	0	0	0	0
Entry Pack (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	4	4	1
Expansion Pack	0	0	0	0	0	0	0	0	0	3	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0
Gold Series (series)	0	0	0	0	0	0	0	0	0	2	0	2	3	2	0	5	2	2	0	0	0	0	0	0	0
Hidden Arsenal (series)	0	0	0	0	0	0	0	0	0	0	1	3	6	3	3	0	0	0	0	0	0	0	0	0	0
Jump Victory Carnival	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0
Legend Duelist (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	4	4	1	1	1	0
Legendary Collection (series)	0	0	0	0	0	0	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0
Master Guide promotional cards (series)	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0
Mattel Action Figure promotional cards	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
McDonald's Promotional Cards	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Monster Figure Collection promotional cards	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0
OTS Tournament Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0
Perfect Rulebook promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
Pharaoh Tour promotional cards	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Premium Pack	0	3	1	0	0	3	1	1	1	2	2	2	1	2	2	2	2	0	0	0	0	0	0	0	0
Shonen Jump promotional cards	0	0	0	0	0	0	2	3	4	3	2	7	2	4	4	6	4	6	1	0	0	0	0	0	0
Sneak Peek Participation Cards	0	0	0	0	0	0	4	4	9	8	3	4	4	5	4	4	4	5	5	3	2	1	0	0	0
Star Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	1	2	0	0	0	0	0	0	0	0
Structure Deck R	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	4	1	0	0	0	0	0	0
The Valuable Book promotional cards	1	1	0	2	1	1	1	1	1	1	1	1	1	1	2	1	1	0	1	0	0	0	0	0	0
V Jump August 1999 Special Present	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
V Jump Edition (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	1	1	0	0	0	0
V Jump promotional cards	0	0	0	0	0	0	0	0	0	5	7	7	7	8	10	8	11	13	2	0	0	0	0	0	0
Value Box	0	0	0	0	0	0	0	0	0	0	0	0	1	2	4	1	1	0	0	0	0	0	0	0	0
Yu-Gi-Oh! 5D's manga promotional cards	0	0	0	0	0	0	0	0	0	0	0	2	2	3	4	3	3	1	0	0	0	0	0	0	0
Yu-Gi-Oh! Day promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	2	1	0	0	0	0	0	0
Yu-Gi-Oh! GX manga promotional cards	0	0	0	0	0	0	0	1	2	3	3	4	3	2	0	0	0	0	0	0	0	0	0	0	0
Yu-Gi-Oh! R promotional cards	0	0	0	0	0	0	1	1	1	1	1	3	0	0	0	0	0	0	0	0	0	0	0	0	0
Yu-Gi-Oh! World Championship prize cards	0	0	0	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1	0	0	0	0	0	0	0
Yu-Gi-Oh! ZEXAL manga promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	4	6	6	7	2	0	0	0	0	0	0	0

By set type

		Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Cover card	Page URL	Modification date	_merge
Set type	Release
Beta set	2017-10-04	1	535	106	1	0	2	5	0	0	1	1	1
Binder	2012-09-21	1	3	3	1	2	0	1	0	0	1	1	1
	2015-04-29	1	3	3	1	0	0	1	0	0	1	1	1
Book promotional card	2004-12-18	1	2	2	1	0	0	1	0	0	1	1	1
	2014-04-04	1	1	1	1	0	0	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Video games promotional card	2011-04-28	1	7	7	1	0	0	1	0	0	1	1	1
	2011-05-10	1	3	3	1	0	0	1	0	0	1	1	1
	2013-12-05	1	3	3	1	0	0	1	0	0	1	1	1
	2014-06-26	1	15	3	1	0	0	5	0	0	1	1	1
	2016-07-16	1	1	1	1	0	0	1	0	0	1	1	1

1865 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Set type
Beta set	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0
Binder	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0
Book promotional card	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
Book promotional cards	1	2	0	2	1	2	1	1	1	2	1	1	2	1	3	2	2	1	1	0	0	0	0	0	0
Booster pack	6	7	4	10	15	40	34	36	44	43	35	48	53	54	59	65	56	52	38	28	31	31	52	53	8
Boss Duel Deck	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0
Bundle	0	0	0	0	0	0	0	0	0	0	0	0	1	2	4	1	1	0	0	0	0	0	0	0	0
Collectible tin	0	0	0	1	2	2	2	3	3	7	10	6	5	4	7	2	2	2	2	1	2	1	1	1	0
Collector's Set	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	0	0	3	2	1	4	0
Core Booster	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Deluxe Edition	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	6	0	0	0	0	0	0	0	0	0
Demo Deck	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	2	2	0	3	0	0	0	0	0
Duel Disk	0	0	0	0	0	0	0	1	1	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0
Duel Disk promotional cards	0	0	0	0	0	0	0	1	1	0	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Duel Terminal	0	0	0	0	0	0	0	0	0	6	4	7	6	9	2	0	0	0	0	0	0	0	0	0	0
Duelist League participation cards	0	0	0	0	4	4	2	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Duelist Set	0	0	0	0	0	0	0	0	0	0	0	0	0	3	5	1	0	0	0	0	0	0	0	0	0
Enhancement Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0
Hobby League participation cards	0	0	0	0	0	2	1	13	12	12	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Magazine promotional card	1	0	0	0	0	0	3	3	4	10	10	17	10	13	14	14	15	20	3	0	0	0	0	0	0
Magazine promotional cards	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Main Deck	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
Manga promotional card	0	0	0	1	0	0	1	4	3	4	4	9	5	9	10	9	10	3	0	0	0	0	0	0	0
Participation card	1	0	0	0	0	0	4	4	9	8	4	5	4	5	4	4	4	5	5	3	2	1	0	0	0
Preconstructed Deck	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	1	0	0	4	0
Prize card	0	0	2	0	0	1	1	1	1	1	1	1	2	1	1	1	1	1	0	0	0	0	0	0	0
Prize cards	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0
Promotional card	2	0	2	1	0	1	1	8	8	5	7	14	19	8	5	5	7	17	5	3	6	2	9	11	7
Promotional cards	2	0	1	1	5	7	2	1	0	0	1	4	3	1	3	2	1	0	0	0	1	0	0	0	0
Special Edition	0	0	0	0	2	3	3	7	12	11	13	8	8	12	2	3	7	8	7	4	2	1	0	0	0
Starter Deck	1	1	0	4	13	18	2	0	3	2	5	4	3	4	8	5	7	4	0	0	0	0	2	0	0
Structure Deck	0	0	2	1	3	0	8	10	8	6	7	6	9	9	8	11	13	17	4	0	0	0	0	0	0
Tournament prize card	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Tournament promotional card	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Vendor Edition	0	0	0	0	0	1	2	2	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Video game promotional card	1	2	0	0	0	0	0	0	5	0	3	4	2	0	0	0	0	0	0	0	0	0	0	0	0
Video games promotional card	0	0	0	1	3	8	7	4	8	4	3	0	4	0	1	1	0	1	0	0	0	0	0	0	0

Debug

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
2932	Legendary Decks II	<NA>	<NA>	The Wicked Worm Beast	(Common,)	<NA>	<NA>	IT	2016-10-06	<NA>	Collector's Set	NaN	https://yugipedia.com/wiki/Booster_4	2022-07-23 09:59:12	both
2977	Legendary Decks II	<NA>	<NA>	Big Insect	(Common,)	<NA>	<NA>	IT	2016-10-06	<NA>	Collector's Set	NaN	https://yugipedia.com/wiki/Booster_4	2022-07-23 09:59:12	both
3022	Legendary Decks II	<NA>	<NA>	Fiend Kraken	(Common,)	<NA>	<NA>	IT	2016-10-06	<NA>	Collector's Set	NaN	https://yugipedia.com/wiki/Booster_4	2022-07-23 09:59:12	both
3070	Legendary Decks II	<NA>	<NA>	Axe Raider	(Common,)	<NA>	SP	2016-10-06	<NA>	Collector's Set	NaN	https://yugipedia.com/wiki/Booster_4	2022-07-23 09:59:12	both
3115	Legendary Decks II	<NA>	<NA>	<NA>	(Common,)	<NA>	SP	2016-10-06	<NA>	Collector's Set	NaN	https://yugipedia.com/wiki/Booster_4	2022-07-23 09:59:12	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
145181	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145182	EX Starter Box	<NA>	Castle Walls	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145183	EX Starter Box	<NA>	Ultimate Offering	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
156162	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156163	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

737 rows × 14 columns

Has nan rarity

array(['Advanced Event Pack 2014 Vol.1',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome attendance cards',
       'Dark Beginning 1', 'Dark Revelation Volume 2', 'Dark Beginning 2',
       'Advanced Tournament Pack 2013 Vol.3',
       'Yu-Gi-Oh! True Duel Monsters: Sealed Memories promotional cards',
       'Dark Revelation Volume 1', 'V Jump April 2013 Tokens',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome invitation cards',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome prize cards',
       'Advanced Tournament Pack 2013 Vol.4',
       'Official Guide Starter Book promotional card',
       'Advanced Event Pack 2013 Vol.2',
       'The Valuable Book 1 promotional cards',
       'Duel Monsters II tournament meeting experience promotional card',
       'Jump Festa 2000',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome participation cards',
       'The Valuable Book character cards',
       '"Blue-Eyes White Dragon" 20th Anniversary Gold Edition',
       '"Blue-Eyes White Dragon" 20th Anniversary Silver Edition',
       '"Dark Magician" Special Card',
       '"Dark Magician Girl" Special Card',
       'Advanced Tournament Pack 2016 Vol.1',
       '25th Anniversary Ultimate Kaiba Set',
       'Asian-English Weekly Shōnen Jump lottery prize cards',
       'Booster 1', 'Booster 3',
       'Challenge from Kaiba Corporation Clear bonus',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Classic Pack 03', 'Deck Build Pack: Tactical Masters',
       'EX Starter Box', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has quantity as print

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
145132	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145181	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
145084	EX Starter Box	<NA>	Lord of D.	(New,)	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145085	EX Starter Box	<NA>	The Flute of Summoning Dragon	(New,)	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145086	EX Starter Box	<NA>	Dark Magician	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145087	EX Starter Box	<NA>	Mystical Elf	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145088	EX Starter Box	<NA>	Feral Imp	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
145179	EX Starter Box	<NA>	Reverse Trap	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145180	EX Starter Box	<NA>	Remove Trap	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145181	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145182	EX Starter Box	<NA>	Castle Walls	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145183	EX Starter Box	<NA>	Ultimate Offering	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both

100 rows × 14 columns

Has nan release

array(["Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Astral Pack Two', 'Raging Battle Sneak Peek Participation Card',
       'Shonen Jump May 2008 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Sneak Peek Participation Cards', 'Spell Ruler',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Duelist League Demo 2010', 'Hobby League 6 participation card B',
       'Shonen Jump June/July 2011 subscription bonus',
       'Dimension of Chaos Sneak Peek Participation Card',
       'Legacy of the Valiant Sneak Peek Participation Card',
       'Shonen Jump Vol. 3, Issue 11 promotional card',
       'Ancient Sanctuary', 'National Championship 2011',
       'Shonen Jump August 2008 subscription bonus',
       'The Lost Millennium: Special Edition',
       'Tournament Pack 2009 Vol.3',
       "Yu-Gi-Oh! 5D's manga promotional cards",
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Curse of Anubis',
       'Invasion: Vengeance Sneak Peek Participation Card',
       'Premium Pack 2', 'Shadow Specters Sneak Peek Participation Card',
       "Structure Deck: Dinosaur's Rage Special Set",
       'Banzai! promotional cards', 'Millennium Pack', 'Premium Pack',
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards",
       'Academy Duel Disk',
       'The New Challengers Sneak Peek Participation Card',
       'Astral Pack One', 'Shonen Jump Vol. 9, Issue 8 promotional card',
       'Tournament Pack 2008 Vol.2',
       'Hobby League 7 participation card B', 'Structure Deck: Marik',
       'Shonen Jump Vol. 6, Issue 9 promotional card',
       'Hobby League 6 participation card C',
       'Shonen Jump May 2006 subscription bonus', 'Magic Ruler',
       'Shonen Jump Vol. 4, Issue 2 promotional card',
       'National Championship 2012',
       'Shonen Jump May 2010 subscription bonus',
       'Shonen Jump Vol. 6, Issue 1 promotional card',
       'Shadow of Infinity: Special Edition',
       'Ancient Prophecy Sneak Peek Participation Card', 'Gold Series',
       'Secrets of Eternity Sneak Peek Participation Card',
       'Shonen Jump Championship Series Prize Cards', 'Ultimate Edition',
       "Yu-Gi-Oh! 5D's Volume 1 promotional card",
       'Yu-Gi-Oh! GX Volume 4 promotional card',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Crossed Souls Sneak Peek Participation Card',
       'Hobby League 7 participation card C',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'Structure Deck: Machine Re-Volt Special Edition',
       'Hobby League 6 participation card D',
       'Shonen Jump Vol. 9, Issue 1 promotional card',
       'National Championship 2013', 'Tournament Pack 2009 Vol.4',
       'Shonen Jump Vol. 10, Issue 1 promotional card',
       'Hobby League 7 participation card D',
       'Shonen Jump Vol. 4, Issue 11 promotional card',
       'Shonen Jump Vol. 7, Issue 6 promotional card',
       'Hobby League 6 participation card E', 'The Sanctuary in the Sky',
       'Tournament Pack 2008 Vol.1',
       'Yu-Gi-Oh! GX manga promotional cards',
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'The Valuable Book promotional cards',
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       'Invader of Darkness',
       'Shonen Jump Vol. 9, Issue 4 promotional card',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'Hobby League 6 participation card F',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Shonen Jump December 2010 subscription bonus',
       'Hobby League 6 participation card A',
       'Hobby League participation cards',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'Yu-Gi-Oh! R promotional cards',
       'Shonen Jump Vol. 10, Issue 4 promotional card',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'Shonen Jump Vol. 5, Issue 1 promotional card', 'Duel Disk',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'Hobby League 7 participation card A',
       'Shonen Jump Vol. 9, Issue 6 promotional card',
       'The Valuable Book character cards', '2013 Collectible Tins',
       '20th Anniversary Duel Set', 'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has print as rarity

array(['Structure Deck R: Machine Dragon Re-Volt', 'Booster 4',
       'Booster 5', 'Booster 6', 'Booster 7', 'Dark Ceremony Edition',
       'Booster 1', 'EX Starter Box'], dtype=object)

Merge failed

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
156162	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156163	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

8

array(['Advanced Tournament Pack 2014 Vol.2', 'Cosmo Blazer',
       'Crossed Souls: Advance Edition', ...,
       'Jump Festa 2005 promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge

Epilogue

Execution completed 26/01/2023 19:22 UTC

HTML export